﻿DROP TABLE IF EXISTS `open_goods_inventory`;
CREATE TABLE `open_goods_inventory` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `goods_id` mediumint(8) unsigned NOT NULL default '0' COMMENT '库存商品ID',
  `color_id` smallint(5) unsigned NOT NULL default '0' COMMENT '库存商品颜色ID',
  `size_id` smallint(5) unsigned NOT NULL default '0' COMMENT '库存商品尺码ID',
  `goods_number_actual` smallint(5) unsigned NOT NULL default '0' COMMENT '实际库存',
  `goods_number_available` smallint(5) unsigned NOT NULL default '0' COMMENT '可用库存',
  `goods_number_alert` smallint(5) unsigned NOT NULL default '0' COMMENT '警戒库存',
  `SPDM` varchar(255) NOT NULL default '0',
  `GG1DM` varchar(255) NOT NULL default '0',
  `GG2DM` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `goodid` (`goods_id`),
  KEY `colorid` (`color_id`),
  KEY `sizeid` (`size_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8